All Hokie, All the Time. Period. Presented by

The Lounge Board

MrBayAreaHokie

Joined: 11/05/2005 Posts: 21888
Likes: 10764

What's this?

What I might do


Create a new column that does a “=“ to the column with the drop down. So in Z34, put in =A34, where Z is the new column and A is the column with the drop down.

Then, do your search against Z instead of A. Maybe the drop down has some garbage in it you don’t want.

(In response to this post by MP4VT2004)

Posted: 11/22/2020 at 10:16PM


+0

Insert a Link

Enter the title of the link here:


Enter the full web address of the link here -- include the "http://" part:


75
Hide This

Current Thread:
 
  Calling on all you Excel ninjas - I need some help... -- MP4VT2004 11/22/2020 8:51PM
  You may have hidden spaces -- wtrva 11/23/2020 2:44PM
  PC Load Letter ** -- bigbadbird 11/23/2020 08:22AM
  What the #$% does that mean??? ** -- MP4VT2004 11/23/2020 08:43AM
  Lookups need to be sorted from what I recall. May not be your issue, but -- Hokie Hokie 11/23/2020 01:56AM
  Make sure you anchor the area of your lookup if you are copying -- TheNuke 11/22/2020 11:29PM
  What I might do -- MrBayAreaHokie 11/22/2020 10:16PM
  Not an excel expert but is the content type consistent? E.g. string or num? ** -- HokieForever 11/22/2020 9:12PM
  The lookup values and drop down list are all text... -- MP4VT2004 11/22/2020 9:20PM
  Possible? Link -- HokieForever 11/22/2020 9:41PM

Tech Sideline is Presented By:

Our Sponsors








vm307